xmlns="http://www.w3.org/2000/svg">  Chat With Us: +91 99871 84296
Download App Download Brochure
Popular Searches
Popular Course Categories
Popular Courses
View All Courses

Advanced Excel Tutorial – Master Excel Formulas, Pivot Tables & Dashboards

  1. Home
  2. Resources
  3. Advanced Excel Tutorial – Master Excel Formulas, Pivot Tables & Dashboards
Curriculum
0% complete
1
Advanced Excel Formulas and Cell References 8
2
Advanced Mathematical and Statistical Functions 8

Advanced Excel Formulas and Cell References

8 topics in this module

1
Understanding Relative, Absolute, and Mixed Cell References
2
Working with Cross-Sheet and Cross-Workbook Formulas
3
Creating and Managing Named Ranges
4
Using Nested Formulas and Complex Calculations
5
Understanding Formula Precedence and Calculation Order
6
Using Formula Auditing and Evaluate Formula Tools
7
Identifying and Resolving Circular References
8
Troubleshooting Formula Errors and Incorrect Results

Advanced Mathematical and Statistical Functions

8 topics in this module

1
Using SUMIF and SUMIFS for Conditional Calculations
2
Applying COUNTIF and COUNTIFS for Criteria-Based Counting
3
Using AVERAGEIF and AVERAGEIFS for Conditional Averages
4
Working with SUBTOTAL and AGGREGATE Functions
5
Applying SUMPRODUCT for Multi-Condition Calculations
6
Using ROUND, ROUNDUP, ROUNDDOWN, and MROUND
7
Applying LARGE, SMALL, MAX, and MIN Functions
8
Using RANK.EQ, PERCENTILE, and QUARTILE Functions
All Resources
Explore Courses

Take the next step in your learning journey

View Courses
whatsapp